package com.exp.mapper;

import com.exp.dto.UserInfDTO;
import com.exp.dto.UserPageQueryDTO;
import com.exp.pojo.UserInf;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.exp.vo.UserInfVO;
import com.github.pagehelper.Page;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 王-自信
* @description 针对表【user_inf】的数据库操作Mapper
* @createDate 2024-11-18 20:52:05
* @Entity hrmapi.pojo.com.ygzj.hrmapi.UserInf
*/
public interface UserInfMapper extends BaseMapper<UserInf> {
    /**
     * 根据用户名查询用户
     */
    @Select("select * from user_inf where loginname = #{loginname}")
    UserInf getByLoginname(String loginname);

    /**
     * 分页查询
     */
    Page<UserInf> pageQuery(UserPageQueryDTO userPageQueryDTO);

    void update(UserInf userInf);

    List<Integer> getDocumentIdsByUserIds(List<Integer> ids);

    List<Integer> getNoticeIdsByUserIds(List<Integer> ids);

    @Select("select * from user_inf where id = #{id}")
    UserInf getByUserId(Integer id);
}




